package cn.liumouren.jzxd.dao;

import cn.liumouren.jzxd.entity.Tag;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 
 * 
 * @author Freeman Liu
 * @email llw599502537@gmail.com
 * @date 2020-10-30 16:28:21
 */
@Mapper
public interface TagDao extends BaseMapper<Tag> {
    @Select("SELECT tb_tag.* FROM `tb_scene_tag`,`tb_tag` WHERE `tb_scene_tag`.`scene_id` = #{sceneId} AND `tb_scene_tag`.`tag_id` = `tb_tag`.`id`")
	List<Tag> getTagsByScenes(String sceneId);
}
